package com.cooper.dao.trade;

import java.util.List;

import net.paoding.rose.jade.annotation.DAO;
import net.paoding.rose.jade.annotation.Insert;
import net.paoding.rose.jade.annotation.ReturnGeneratedKeys;
import net.paoding.rose.jade.annotation.SQL;

import com.cooper.entity.OrderItem;

@DAO
public interface OrderItemDAO {

	@ReturnGeneratedKeys
	@Insert(tableName="td_order_item")
	Long addOrderItem(OrderItem orderItem) throws Exception;
	
	@SQL("select * from td_order_item where deleted='n' and order_num=:1 ")
	List<OrderItem> getOrderItemListByOrderNumber(String orderNum) throws Exception;
	
}
